Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerAccountID (FK)(PK) | A unique identifier for a customer account. | ID_CTAC | Identity | integer | CustomerAccount(LE_CTAC) |
CustomerAccountCardID (FK)(PK) | A 16 digit Credit or Debit card PAN as defined by ISO-7812, uniquely identifying CustomerAccountCard. | AI_ACNT_CT_CRD | CreditDebitCardPAN | varchar(20) | CustomerAccountCard(LE_ACNT_CT_CRD) |
StatusCode | A unqiue retailer assigned code denoting the status of the assignment. | SC_ASGMT_CTAC_CRD | Code2Status | char(2) | |
EffectiveDate | The date at which the assignment commences. | DC_EF | EffectiveDate | date | |
ExpirationDate | The date at which the assignment finishes. | DC_EP | ExpirationDate | date | |